How to Find Records with the Data Form in Excel 20130

In a large data list, trying to find a particular record by moving from record to record in Excel 2013 — or even moving ten records at a time with the scroll bar — can take all day. Rather than waste time trying to manually search for a record, you can use the Criteria button in the data form to look it up. When you click the Criteria button, Excel clears all the field entries in...

Read More...

How to Name a Cell or Cell Range in Excel 20130

By assigning descriptive names to cells and cell ranges in Excel 2013, you can go a long way toward keeping on top of the location of important information in a worksheet. Rather than try to associate random cell coordinates with specific...

Read More...

How to Create a Table in Excel 20070

You can create a table in Excel 2007 (a list or database in previous Excel versions) to help you manage and analyze related data. The purpose of an Excel table is not so much to calculate new values but rather to store lots of information...

Read More...

How to Repeat Row and Column Headings When You Print in Excel 20070

Excel 2007’s Print Titles command enables you to print particular row and column headings on each page of the report. Print titles are important in multipage reports where the columns and rows of related data spill over to other pages that no longer...

Read More...

How to Protect an Excel 2007 Workbook0

Excel 2007 includes a Protect Workbook command that prevents others from making changes to the layout of the worksheets in a workbook. You can assign a password when you protect a workbook so that only those who know the password...

Read More...

Using Logical Excel Functions in Excel 2007 Formulas0

Excel 2007 uses seven logical functions — AND, FALSE, IF, IFERROR, NOT, OR, and TRUE — which appear on the Logical command button’s drop-down menu on the Excel Formulas tab of the Ribbon. All the logical functions return either the logical TRUE or logical FALSE when their functions are evaluated.` Here is an Excel functions list that shows the logical function...

Read More...

How to Change Column Width and Row Height in Excel 20070

In Excel 2007, you can change any column widths or row heights in your worksheets to improve the readability and appearance of data. For example, if your worksheet contains many numbers, you can widen the columns to make the worksheet less...

Read More...

Looking Up Data in Excel 2007 with HLOOKUP and VLOOKUP0

The most popular of the lookup functions in Excel 2007 are HLOOKUP (for Horizontal Lookup) and VLOOKUP (for Vertical Lookup). These functions are located in the Lookup & Reference category on the Formulas tab of the Ribbon and...

Read More...

Splitting an Excel 2007 Worksheet Window0

In Excel 2007, you can split the worksheet window into separate panes and scroll the worksheet in each pane so that you can easily compare data from two separate worksheet locations. You can make the panes in a workbook window disappear...

Read More...

Filtering and Sorting an Excel 2007 Pivot Table0

You can filter and sort the data in an Excel 2007 pivot table to display a subset of data arranged how you want to view it. Excel automatically adds drop-down filter arrows to the Report Filter field as well as the labels for the Column...

Read More...

Getting to Know the Parts of an Excel 2007 Chart0

The typical chart (or graph) in Excel 2007 comprises several distinct parts, including the chart area, data series, axes, legend, plot area, gridlines, data markers, and more. The following list summarizes the parts of a typical chart, some of which...

Read More...

Using Built-in Add-In Programs in Excel 20070

Add-in programs are small modules that extend the power of Excel 2007 by giving you access to a wide array of features and calculating functions not otherwise offered in the application. There are three different types of add-ins: Built-in...

Read More...

Create a Pivot Table in Excel 20070

A pivot table is a special type of summary table that’s totally unique to Excel 2007. Pivot tables are great for summarizing values in a table because they do their magic without making you createformulas to perform the calculations....

Read More...